cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure Database Support Blog
Options
357

Lesson Learned #491: Monitoring Blocking Issues in Azure SQL Database

Jose_Manuel_Jurado on May 21 2024 04:43 AM
Time ago, we wrote an article Lesson Learned #22: How to identify blocking issues? today, I would like to enhance this t...
707

Lesson Learned #490: Monitoring Access from Specific Applications to Azure SQL Database

Jose_Manuel_Jurado on May 18 2024 08:09 AM
This week, I worked on a service request where our customer needed to ensure that specific applications could not connec...
678

Lesson Learned #489:Investigating CPU Spikes with Query Store Overall Resource Consumption Report

Jose_Manuel_Jurado on May 17 2024 01:44 AM
Yesterday, I worked on a customer who experienced a CPU spike that went 90% during the timeframe of 19:00 to 21:00. I wo...
842

Lesson Learned #488: A severe error occurred on the current command. Operation cancelled by user.

Jose_Manuel_Jurado on May 16 2024 12:32 AM
Today, I worked on a service request that our customer got this error message: "A severe error occurred on the current c...
866

Lesson Learned #487: Identifying Parallel and High-Volume Queries in Azure SQL Database

Jose_Manuel_Jurado on May 15 2024 03:57 AM
Today, I worked on a service request that our customer needs to monitor and optimize queries that can significantly impa...
827

Lesson Learned #486: Snapshot Isolation Transaction Failed Due to a Concurrent DDL Statement

Jose_Manuel_Jurado on May 14 2024 01:33 AM
Today, we worked on a service request that our customer faced the following error message: Msg 3961, Level 16, State 1, ...
633

Lesson Learned #485: Index Recomendation or the Importance of Index Selection in SQL Server

Jose_Manuel_Jurado on May 13 2024 09:56 AM
Today, I worked on a service request that caught my attention regarding index missing recommendations given by SQL Serve...
790

Lesson Learned #484: Database Performance Monitoring with PowerShell and ReadScale-Out Environments

Jose_Manuel_Jurado on May 10 2024 06:20 AM
Today, I handled a service request from our customer seeking additional information on performance monitoring for ReadSc...
1,561

Lesson Learned #483: Optimizing Performance in Azure SQL Database ReadScale Out Databases

Jose_Manuel_Jurado on May 09 2024 08:02 AM
Today, I worked on a service request that our customer has a Business Critical database with 4 vCores and Read-Scale Out...
1,221

SQL MI Restore with valid SAS key failing with Operating System Error 86

SamGarth on Apr 22 2024 01:39 AM
We will provide details about a workaround for resolving the "Operating System Error 86" encountered during database res...
1,580

Lesson Learned #482: Identifying Potential Duplicate Statistics

Jose_Manuel_Jurado on Apr 01 2024 11:41 AM
Some time ago, we encountered a support case where a customer experienced significant delays in updating auto-created an...
1,927

Lesson Learned #480:Application-Level Locking in Azure SQL Database - Ensuring Exclusive Access

Jose_Manuel_Jurado on Mar 30 2024 02:41 PM
In certain circumstances, we need to apply production changes or exclusive access to one or more resources by only one i...
1,484

Lesson Learned #481: Query Performance Analysis Tips

Jose_Manuel_Jurado on Mar 18 2024 08:59 AM
When working with databases, high resource usage or a query reporting a timeout could indicate that the statistics of th...
1,866

Lesson Learned #479:Loading Data from Parquet to Azure SQL Database using C# and SqlBulkCopy

Jose_Manuel_Jurado on Mar 15 2024 12:13 PM
In the realm of big data and cloud computing, efficiently managing and transferring data between different platforms and...
2,791

QTip: Connect to Azure SQL DB using Entra SPN (service principal)

jaigarcimicrosoft on Feb 02 2024 10:54 AM
Connect to Azure SQL DB using Entra SPN
2,031

Lesson Learned #478: Identifying TLS Version Using Azure SQL Auditing

Jose_Manuel_Jurado on Jan 16 2024 08:36 AM
Today, we worked on a service request where our customer needs to know the TLS version that their application are using....
2,258

Lesson Learned #477:NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set

Jose_Manuel_Jurado on Jan 16 2024 04:46 AM
In the realm of SQL Server, certain combinations of commands and functions can lead to unexpected conflicts and errors. ...
2,250

Lesson Learned #476:Identifying Sleeping Sessions with Open Transactions in Azure SQL Database

Jose_Manuel_Jurado on Jan 16 2024 04:14 AM
In SQL Server environments, managing session states and transactions is key to ensuring optimal database performance. A ...
3,089

QTip: Configure Azure SQL DB to receive alert when failover occurs in failover group or geo replica

jaigarcimicrosoft on Jan 16 2024 01:50 AM
How to receive notification when failover happens in failover group and geo replica
2,735

Lesson Learned #475:Cross-Database Queries Read and Write in Azure SQL Database.

Jose_Manuel_Jurado on Jan 14 2024 04:30 AM
This week, we addressed a service request from a customer who wanted to keep two tables synchronized across different da...
2,792

Lesson Learned #474:Identifying and Preventing Unauthorized Application Access to Azure SQL Database

Jose_Manuel_Jurado on Jan 13 2024 01:29 AM
In recent scenarios encountered with our customers, we have come across a specific need: restricting certain users from ...

Latest Comments

Roberto_Carrancio
in Lesson Learned #487: Identifying Parallel and High-Volume Queries in Azure SQL Database on May 17 2024 04:35 AM
Hi @Jose_Manuel_Jurado I can see values ​​up to 500 in max_DOP column if I select the sys.dm_exec_query_stats DMV. What does that value represent? Thanks in advance
0 Likes
Devi49
in Azure Data Warehouse Health Check Query on May 14 2024 02:18 PM
I couldn’t see the query used for checking the quick health check. Could you please share it
0 Likes
anoop50
in Lesson Learned #251: Error 40532 using Private Endpoint IP in the server name on Apr 25 2024 01:57 AM
I used this method, but I am still unable to connect using private end point ip and useraname as username@servername to my managed instance. My username looks like email address removed for privacy reasons. Also I able to connect to port 1433 using IP from destination. Please let me know what else i...
0 Likes
saeed_aliakbarian
in Lesson Learned #287: Contains an unresolved reference to an object due to database collation on Apr 20 2024 06:04 AM
In brief the error happens when trying to create a dacpac/bacpac from a database or database project (or build the database project) that has one of the following situations:1. SELECT * : using star(*) in a SELECT statement in a view2. 3 Part names: Including database name when referencing a table (...
0 Likes
SightBeyondSight
in Lesson Learned #482: Identifying Potential Duplicate Statistics on Apr 19 2024 06:02 AM
Great lesson and something one would not even think about.Suggestion to change code @line 21 to :STRING_AGG(CONVERT(VARCHAR(max),sc1.StatisticName),'', '') WITHIN GROUP (ORDER BY sc1.StatisticName) AS StatisticsNames,This will prevent error when the comma delimeted statistics names exceed 8000 chara...
0 Likes